USE [texchange_db]
GO

/****** Object:  StoredProcedure [dbo].[SP_UpdateComp]    Script Date: 05/29/2011 19:50:30 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE proc [dbo].[SP_UpdateComp] 
  @id  bigint,
  @name nvarchar(100)  = '',
  @country_id int,
  @city nvarchar(150) = '',
  @postcode nvarchar(50) = '',
  @address nvarchar(100) = '',
  @type_company_id int,
  @operating_activity nvarchar(200) = '',
  @company_status int,
  @member_type_id int,
  @telephone nvarchar(50) = '',
  @ext nvarchar(4) = '',
  @fax nvarchar(50) = '',
  @mobile nvarchar(50) = '',
  @website nvarchar(50) = '',
  @contact_person nvarchar(50) = '',
  @language nvarchar(50) = '',
  @job_title nvarchar(50) = ''
as
	UPDATE Company SET [name] = @name, country_id = @country_id, 
	city=@city, postcode=@postcode,[address]=@address, type_company_id=@type_company_id,
	operating_activity=@operating_activity, company_status= @company_status, member_type_id = @member_type_id,
	telephone=@telephone, fax=@fax, mobile= @mobile, website=@website,contact_person=@contact_person,
	[language]=@language,job_title=@job_title, ext=@ext
	WHERE id=@id


GO


